{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Source","IF","Advanced","Consolidate","Subtotal","Pivot"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Source","index":0,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["კოდი","თანხა"]
[1003,68]
[1005,94]
[1004,466]
[1002,364]
[1001,53]
[1002,34]
[1005,734]
[1002,354]
[1001,534]
[1001,675]
[1003,555]
[1003,436]
[1004,754]
[1002,55]
[1004,35]
[1001,56]
[1005,54]
[1001,73]
[1002,366]
[1003,288]
[1004,49]
[1001,54]
[1002,934]
[1003,356]
[1003,463]
[1005,453]
[1005,53]
[1004,23]
[1004,645]
[1002,53]
[1003,34]
[1001,544]
[1003,324]
[1003,68]
[1002,53]
[1003,56]
[1003,345]
[1004,354]
[1001,74]
[1003,57]
[1004,662]
[1005,534]
[1005,45]
[1004,546]
[1002,46]
[1002,543]
[1001,856]
[1004,646]
[1001,553]
[1004,364]

{"sheet":"IF","index":1,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["კოდი","თანხა","მიმდინარე ჯამი","კოდის შეცვლა"]
[1001,553,3472,"ბოლოა!"]
[1002,543,2802,"ბოლოა!"]
[1003,57,3050,"ბოლოა!"]
[1004,364,4544,"ბოლოა!"]
[1005,45,1967,"ბოლოა!"]
[1001,53,53,"ჯერ არა"]
[1001,534,587,"ჯერ არა"]
[1001,675,1262,"ჯერ არა"]
[1001,56,1318,"ჯერ არა"]
[1001,73,1391,"ჯერ არა"]
[1001,54,1445,"ჯერ არა"]
[1001,544,1989,"ჯერ არა"]
[1001,74,2063,"ჯერ არა"]
[1001,856,2919,"ჯერ არა"]
[1002,364,364,"ჯერ არა"]
[1002,34,398,"ჯერ არა"]
[1002,354,752,"ჯერ არა"]
[1002,55,807,"ჯერ არა"]
[1002,366,1173,"ჯერ არა"]
[1002,934,2107,"ჯერ არა"]
[1002,53,2160,"ჯერ არა"]
[1002,53,2213,"ჯერ არა"]
[1002,46,2259,"ჯერ არა"]
[1003,68,68,"ჯერ არა"]
[1003,555,623,"ჯერ არა"]
[1003,436,1059,"ჯერ არა"]
[1003,288,1347,"ჯერ არა"]
[1003,356,1703,"ჯერ არა"]
[1003,463,2166,"ჯერ არა"]
[1003,34,2200,"ჯერ არა"]
[1003,324,2524,"ჯერ არა"]
[1003,68,2592,"ჯერ არა"]
[1003,56,2648,"ჯერ არა"]
[1003,345,2993,"ჯერ არა"]
[1004,466,466,"ჯერ არა"]
[1004,754,1220,"ჯერ არა"]
[1004,35,1255,"ჯერ არა"]
[1004,49,1304,"ჯერ არა"]
[1004,23,1327,"ჯერ არა"]
[1004,645,1972,"ჯერ არა"]
[1004,354,2326,"ჯერ არა"]
[1004,662,2988,"ჯერ არა"]
[1004,546,3534,"ჯერ არა"]
[1004,646,4180,"ჯერ არა"]
[1005,94,94,"ჯერ არა"]
[1005,734,828,"ჯერ არა"]
[1005,54,882,"ჯერ არა"]
[1005,453,1335,"ჯერ არა"]
[1005,53,1388,"ჯერ არა"]
[1005,534,1922,"ჯერ არა"]

{"sheet":"Advanced","index":2,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["კოდი","თანხა",null,"კოდი"]
[1001,53,null,1001,{"$f":"DSUM($A$1:$B$51, \"თანხა\", $D$1:D2)-SUM($E$1:E1)","v":3472}]
[1001,534,null,1002,{"$f":"DSUM($A$1:$B$51, \"თანხა\", $D$1:D3)-SUM($E$1:E2)","v":2802}]
[1001,675,null,1003,{"$f":"DSUM($A$1:$B$51, \"თანხა\", $D$1:D4)-SUM($E$1:E3)","v":3050}]
[1001,56,null,1004,{"$f":"DSUM($A$1:$B$51, \"თანხა\", $D$1:D5)-SUM($E$1:E4)","v":4544}]
[1001,73,null,1005,{"$f":"DSUM($A$1:$B$51, \"თანხა\", $D$1:D6)-SUM($E$1:E5)","v":1967}]
[1001,54]
[1001,544]
[1001,74]
[1001,856]
[1001,553]
[1002,364]
[1002,34]
[1002,354]
[1002,55]
[1002,366]
[1002,934]
[1002,53]
[1002,53]
[1002,46]
[1002,543]
[1003,68]
[1003,555]
[1003,436]
[1003,288]
[1003,356]
[1003,463]
[1003,34]
[1003,324]
[1003,68]
[1003,56]
[1003,345]
[1003,57]
[1004,466]
[1004,754]
[1004,35]
[1004,49]
[1004,23]
[1004,645]
[1004,354]
[1004,662]
[1004,546]
[1004,646]
[1004,364]
[1005,94]
[1005,734]
[1005,54]
[1005,453]
[1005,53]
[1005,534]
[1005,45]

{"sheet":"Consolidate","index":3,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["კოდი","თანხა",null,null,"თანხა"]
[1003,68,null,1003,3050]
[1005,94,null,1005,1967]
[1004,466,null,1004,4544]
[1002,364,null,1002,2802]
[1001,53,null,1001,3472]
[1002,34]
[1005,734]
[1002,354]
[1001,534]
[1001,675]
[1003,555]
[1003,436]
[1004,754]
[1002,55]
[1004,35]
[1001,56]
[1005,54]
[1001,73]
[1002,366]
[1003,288]
[1004,49]
[1001,54]
[1002,934]
[1003,356]
[1003,463]
[1005,453]
[1005,53]
[1004,23]
[1004,645]
[1002,53]
[1003,34]
[1001,544]
[1003,324]
[1003,68]
[1002,53]
[1003,56]
[1003,345]
[1004,354]
[1001,74]
[1003,57]
[1004,662]
[1005,534]
[1005,45]
[1004,546]
[1002,46]
[1002,543]
[1001,856]
[1004,646]
[1001,553]
[1004,364]

{"sheet":"Subtotal","index":4,"n_rows":57,"n_cols":2,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["კოდი","თანხა"]
[1001,53]
[1001,534]
[1001,675]
[1001,56]
[1001,73]
[1001,54]
[1001,544]
[1001,74]
[1001,856]
[1001,553]
["1001 Total",{"$f":"SUBTOTAL(9,B2:B11)","v":3472}]
[1002,364]
[1002,34]
[1002,354]
[1002,55]
[1002,366]
[1002,934]
[1002,53]
[1002,53]
[1002,46]
[1002,543]
["1002 Total",{"$f":"SUBTOTAL(9,B13:B22)","v":2802}]
[1003,68]
[1003,555]
[1003,436]
[1003,288]
[1003,356]
[1003,463]
[1003,34]
[1003,324]
[1003,68]
[1003,56]
[1003,345]
[1003,57]
["1003 Total",{"$f":"SUBTOTAL(9,B24:B35)","v":3050}]
[1004,466]
[1004,754]
[1004,35]
[1004,49]
[1004,23]
[1004,645]
[1004,354]
[1004,662]
[1004,546]
[1004,646]
[1004,364]
["1004 Total",{"$f":"SUBTOTAL(9,B37:B47)","v":4544}]
[1005,94]
[1005,734]
[1005,54]
[1005,453]
[1005,53]
[1005,534]
[1005,45]
["1005 Total",{"$f":"SUBTOTAL(9,B49:B55)","v":1967}]
["Grand Total",{"$f":"SUBTOTAL(9,B2:B55)","v":15835}]

{"sheet":"Pivot","index":5,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["კოდი","თანხა"]
[1003,68]
[1005,94]
[1004,466]
[1002,364,null,"Sum of თანხა"]
[1001,53,null,"კოდი","Total"]
[1002,34,null,1001,3472]
[1005,734,null,1002,2802]
[1002,354,null,1003,3050]
[1001,534,null,1004,4544]
[1001,675,null,1005,1967]
[1003,555,null,"Grand Total",15835]
[1003,436]
[1004,754]
[1002,55,null,"Sum of თანხა"]
[1004,35,null,"კოდი","Total"]
[1001,56,null,1001,3472]
[1005,54,null,1002,2802]
[1001,73,null,1003,3050]
[1002,366,null,1004,4544]
[1003,288,null,1005,1967]
[1004,49,null,"Grand Total",15835]
[1001,54]
[1002,934]
[1003,356]
[1003,463]
[1005,453]
[1005,53]
[1004,23]
[1004,645]
[1002,53]
[1003,34]
[1001,544]
[1003,324]
[1003,68]
[1002,53]
[1003,56]
[1003,345]
[1004,354]
[1001,74]
[1003,57]
[1004,662]
[1005,534]
[1005,45]
[1004,546]
[1002,46]
[1002,543]
[1001,856]
[1004,646]
[1001,553]
[1004,364]